package jpa.entitys.promis.sales;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;

import jpa.entitys.common.CommonEntity;


/**
 * The persistent class for the MKT_REQUEST_DTL database table.
 * 
 */
@Entity
@Table(name="MKT_REQUEST_DTL")
@NamedQueries({
    @NamedQuery(name = "MktRequestDtl.findAll", query = " SELECT c FROM MktRequestDtl c "),
    @NamedQuery(name = "MktRequestDtl.findById", query = " SELECT c FROM MktRequestDtl c WHERE c.id = :Id "),
    @NamedQuery(name = "MktRequestDtl.findByStatus", query = " SELECT c FROM MktRequestDtl c WHERE c.syncIsstaging = 'N'"),
})
public class MktRequestDtl extends CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private MktRequestDtlPK id;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="BOOKING_NUMBER")
	private BigDecimal bookingNumber;

	@Column(name="BOOKING_SERIES")
	private String bookingSeries;

	@Column(name="BUILDING_PHASE_CODE")
	private String buildingPhaseCode;

	@Column(name="CHARGE_AMOUNT")
	private BigDecimal chargeAmount;

	@Column(name="CHARGE_TEMP_ID")
	private String chargeTempId;

	@Column(name="COMPANY_REF")
	private String companyRef;

	@Column(name="CONTRACT_DISCOUNT_AMOUNT")
	private BigDecimal contractDiscountAmount;

	@Column(name="CONTRACT_DISCOUNT_AMTPERSWQ")
	private BigDecimal contractDiscountAmtperswq;

	@Column(name="CONTRACT_DISCOUNT_PERCENT")
	private BigDecimal contractDiscountPercent;

	@Column(name="CONTRACT_DISCOUNT_PERSWQ")
	private BigDecimal contractDiscountPerswq;

	@Column(name="CREATED_BY")
	private String createdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Column(name="CUSTOMER_CODE")
	private String customerCode;

	@Column(name="CUSTOMER_NAME")
	private String customerName;

	@Column(name="DOCUMENT_TYPE")
	private String documentType;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="FLOOR_ZONE_CODE")
	private String floorZoneCode;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	private String issync;

	@Column(name="LAST_UPD_BY")
	private String lastUpdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPD_ON")
	private Date lastUpdOn;

	@Column(name="LIST_PRICE_CODE")
	private String listPriceCode;

	@Column(name="LIST_PRICE_SWQ")
	private BigDecimal listPriceSwq;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="NET_PRICE")
	private BigDecimal netPrice;

	@Column(name="NET_PRICE_SWQ")
	private BigDecimal netPriceSwq;

	@Column(name="PAYMENT_TERM")
	private String paymentTerm;

	@Column(name="PROJECT_REF")
	private String projectRef;

	@Column(name="PROMOTION_DISCOUNT")
	private BigDecimal promotionDiscount;

	@Column(name="PROPERTY_TYPE_CODE")
	private String propertyTypeCode;

	@Column(name="REFUND_AMOUNT")
	private BigDecimal refundAmount;

	private String remarks;

	@Column(name="SALE_PRICE")
	private BigDecimal salePrice;

	private String status;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_PK_ID")
	private String syncPkId;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TOTAL_ADJUSTED")
	private BigDecimal totalAdjusted;

	@Column(name="TOTAL_DISCOUNT")
	private BigDecimal totalDiscount;

	@Column(name="TOTAL_PAID")
	private BigDecimal totalPaid;

	@Column(name="TOTAL_PRICE")
	private BigDecimal totalPrice;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="VOUCHER_DATE")
	private Date voucherDate;

    public MktRequestDtl() {
    }

	public MktRequestDtlPK getId() {
		return this.id;
	}

	public void setId(MktRequestDtlPK id) {
		this.id = id;
	}
	
	public BigDecimal getBookingNumber() {
		return this.bookingNumber;
	}

	public void setBookingNumber(BigDecimal bookingNumber) {
		this.bookingNumber = bookingNumber;
	}

	public String getBookingSeries() {
		return this.bookingSeries;
	}

	public void setBookingSeries(String bookingSeries) {
		this.bookingSeries = bookingSeries;
	}

	public String getBuildingPhaseCode() {
		return this.buildingPhaseCode;
	}

	public void setBuildingPhaseCode(String buildingPhaseCode) {
		this.buildingPhaseCode = buildingPhaseCode;
	}

	public BigDecimal getChargeAmount() {
		return this.chargeAmount;
	}

	public void setChargeAmount(BigDecimal chargeAmount) {
		this.chargeAmount = chargeAmount;
	}

	public String getChargeTempId() {
		return this.chargeTempId;
	}

	public void setChargeTempId(String chargeTempId) {
		this.chargeTempId = chargeTempId;
	}

	public String getCompanyRef() {
		return this.companyRef;
	}

	public void setCompanyRef(String companyRef) {
		this.companyRef = companyRef;
	}

	public BigDecimal getContractDiscountAmount() {
		return this.contractDiscountAmount;
	}

	public void setContractDiscountAmount(BigDecimal contractDiscountAmount) {
		this.contractDiscountAmount = contractDiscountAmount;
	}

	public BigDecimal getContractDiscountAmtperswq() {
		return this.contractDiscountAmtperswq;
	}

	public void setContractDiscountAmtperswq(BigDecimal contractDiscountAmtperswq) {
		this.contractDiscountAmtperswq = contractDiscountAmtperswq;
	}

	public BigDecimal getContractDiscountPercent() {
		return this.contractDiscountPercent;
	}

	public void setContractDiscountPercent(BigDecimal contractDiscountPercent) {
		this.contractDiscountPercent = contractDiscountPercent;
	}

	public BigDecimal getContractDiscountPerswq() {
		return this.contractDiscountPerswq;
	}

	public void setContractDiscountPerswq(BigDecimal contractDiscountPerswq) {
		this.contractDiscountPerswq = contractDiscountPerswq;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public String getCustomerName() {
		return this.customerName;
	}

	public void setCustomerName(String customerName) {
		this.customerName = customerName;
	}

	public String getDocumentType() {
		return this.documentType;
	}

	public void setDocumentType(String documentType) {
		this.documentType = documentType;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getFloorZoneCode() {
		return this.floorZoneCode;
	}

	public void setFloorZoneCode(String floorZoneCode) {
		this.floorZoneCode = floorZoneCode;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getLastUpdBy() {
		return this.lastUpdBy;
	}

	public void setLastUpdBy(String lastUpdBy) {
		this.lastUpdBy = lastUpdBy;
	}

	public Date getLastUpdOn() {
		return this.lastUpdOn;
	}

	public void setLastUpdOn(Date lastUpdOn) {
		this.lastUpdOn = lastUpdOn;
	}

	public String getListPriceCode() {
		return this.listPriceCode;
	}

	public void setListPriceCode(String listPriceCode) {
		this.listPriceCode = listPriceCode;
	}

	public BigDecimal getListPriceSwq() {
		return this.listPriceSwq;
	}

	public void setListPriceSwq(BigDecimal listPriceSwq) {
		this.listPriceSwq = listPriceSwq;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public BigDecimal getNetPrice() {
		return this.netPrice;
	}

	public void setNetPrice(BigDecimal netPrice) {
		this.netPrice = netPrice;
	}

	public BigDecimal getNetPriceSwq() {
		return this.netPriceSwq;
	}

	public void setNetPriceSwq(BigDecimal netPriceSwq) {
		this.netPriceSwq = netPriceSwq;
	}

	public String getPaymentTerm() {
		return this.paymentTerm;
	}

	public void setPaymentTerm(String paymentTerm) {
		this.paymentTerm = paymentTerm;
	}

	public String getProjectRef() {
		return this.projectRef;
	}

	public void setProjectRef(String projectRef) {
		this.projectRef = projectRef;
	}

	public BigDecimal getPromotionDiscount() {
		return this.promotionDiscount;
	}

	public void setPromotionDiscount(BigDecimal promotionDiscount) {
		this.promotionDiscount = promotionDiscount;
	}

	public String getPropertyTypeCode() {
		return this.propertyTypeCode;
	}

	public void setPropertyTypeCode(String propertyTypeCode) {
		this.propertyTypeCode = propertyTypeCode;
	}

	public BigDecimal getRefundAmount() {
		return this.refundAmount;
	}

	public void setRefundAmount(BigDecimal refundAmount) {
		this.refundAmount = refundAmount;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public BigDecimal getSalePrice() {
		return this.salePrice;
	}

	public void setSalePrice(BigDecimal salePrice) {
		this.salePrice = salePrice;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncPkId() {
		return this.syncPkId;
	}

	public void setSyncPkId(String syncPkId) {
		this.syncPkId = syncPkId;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public BigDecimal getTotalAdjusted() {
		return this.totalAdjusted;
	}

	public void setTotalAdjusted(BigDecimal totalAdjusted) {
		this.totalAdjusted = totalAdjusted;
	}

	public BigDecimal getTotalDiscount() {
		return this.totalDiscount;
	}

	public void setTotalDiscount(BigDecimal totalDiscount) {
		this.totalDiscount = totalDiscount;
	}

	public BigDecimal getTotalPaid() {
		return this.totalPaid;
	}

	public void setTotalPaid(BigDecimal totalPaid) {
		this.totalPaid = totalPaid;
	}

	public BigDecimal getTotalPrice() {
		return this.totalPrice;
	}

	public void setTotalPrice(BigDecimal totalPrice) {
		this.totalPrice = totalPrice;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public Date getVoucherDate() {
		return this.voucherDate;
	}

	public void setVoucherDate(Date voucherDate) {
		this.voucherDate = voucherDate;
	}

}